﻿CREATE PROCEDURE [dbo].[GetAlertRules]
AS
	select
		alert_rule_id as Id,
		entity_type_property_id as EntityTypePropertyId,
		int_warning_value as IntWarningValue,
		int_alert_value as IntAlertValue,
		bigint_alert_value as BigIntAlertValue,
		bigint_warning_value as BigIntWarningValue,
		string_warning_value as StringWarningValue,
		string_warning_type as StringWarningType,
		string_alert_value as StringAlertValue,
		string_alert_type as StringAlertType,
		datetime_warning_value as DateTimeWarningValue,
		datetime_warning_type as DateTimeWarningType,
		datetime_alert_value as DateTimeAlertValue,
		datetime_alert_type as DateTimeAlertType,
		name as Name,
		[description] as Description,
		cause as Cause,
		resolution as Resolution
	from
		dbo.AlertRule;